SetConditionalFormatting(CellRange[],IConditionalFormattingRule[]) Method

In This Topic

Sets conditional formatting for specified ranges of cells on the sheet based on specified rules.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SetConditionalFormatting( _
   ByVal cellRanges() As CellRange, _
   ByVal ParamArray rules() As IConditionalFormattingRule _
)

'Usage
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim rules() As IConditionalFormattingRule
 
instance.SetConditionalFormatting(cellRanges, rules)

public void SetConditionalFormatting( 
   CellRange[] cellRanges,
   params IConditionalFormattingRule[] rules
)

Parameters

cellRanges: The cell ranges
rules: The specified rules to apply for a specified range of cells

Example

This example uses the SetConditionalFormatting method.

C#
VB.NET

Reference

SheetView Class
SheetView Members
Overload List